Tabela AttributeValue

Definicja tabeli AttributeValue

Name

AttributeValue

Code

AttributeValue

Comment

 


Lista kolumn tabeli AttributeValue

Name

Code

SequenceNo

SequenceNo

ValueNo

ValueNo

ChangeNo

ChangeNo

DateValue

DateValue

ResultValue

ResultValue

InsertDay

InsertDay

InsertingPerson

InsertingPerson

PerfPerson

PerfPerson

LowerNorm

LowerNorm

UpperNorm

UpperNorm

Comments

Comments

ResultValueID

ResultValueID

AttributeValueID

AttributeValueID

AttributeID

AttributeID

DescriptiveDataID

DescriptiveDataID

InterpretationTypeID

InterpretationTypeID

DictionaryValueID

DictionaryValueID

FormInstanceID

FormInstanceID

UnitID

UnitID

X

X

Y

Y


Kolumna SequenceNo tabeli AttributeValue

Definicja kolumny SequenceNo tabeli AttributeValue

Name

SequenceNo

Code

SequenceNo

Data Type

NUMBER(5)

Mandatory

Yes

Comment

 


Kolumna ValueNo tabeli AttributeValue

Definicja kolumny ValueNo tabeli AttributeValue

Name

ValueNo

Code

ValueNo

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna ChangeNo tabeli AttributeValue

Definicja kolumny ChangeNo tabeli AttributeValue

Name

ChangeNo

Code

ChangeNo

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna DateValue tabeli AttributeValue

Definicja kolumny DateValue tabeli AttributeValue

Name

DateValue

Code

DateValue

Data Type

DATE

Mandatory

No

Comment

 


Kolumna ResultValue tabeli AttributeValue

Definicja kolumny ResultValue tabeli AttributeValue

Name

ResultValue

Code

ResultValue

Data Type

VARCHAR2(400)

Mandatory

No

Comment

 


Kolumna InsertDay tabeli AttributeValue

Definicja kolumny InsertDay tabeli AttributeValue

Name

InsertDay

Code

InsertDay

Data Type

DATE

Mandatory

No

Comment

 


Kolumna InsertingPerson tabeli AttributeValue

Definicja kolumny InsertingPerson tabeli AttributeValue

Name

InsertingPerson

Code

InsertingPerson

Data Type

NUMBER(10)

Mandatory

No

Comment

PL: Osoba wstawiajaca rekord
EN: Person inserting record


Kolumna PerfPerson tabeli AttributeValue

Definicja kolumny PerfPerson tabeli AttributeValue

Name

PerfPerson

Code

PerfPerson

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna LowerNorm tabeli AttributeValue

Definicja kolumny LowerNorm tabeli AttributeValue

Name

LowerNorm

Code

LowerNorm

Data Type

VARCHAR2(255)

Mandatory

No

Comment

 


Kolumna UpperNorm tabeli AttributeValue

Definicja kolumny UpperNorm tabeli AttributeValue

Name

UpperNorm

Code

UpperNorm

Data Type

VARCHAR2(255)

Mandatory

No

Comment

 


Kolumna Comments tabeli AttributeValue

Definicja kolumny Comments tabeli AttributeValue

Name

Comments

Code

Comments

Data Type

VARCHAR2(255)

Mandatory

No

Comment

 


Kolumna ResultValueID tabeli AttributeValue

Definicja kolumny ResultValueID tabeli AttributeValue

Name

ResultValueID

Code

ResultValueID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna AttributeValueID tabeli AttributeValue

Definicja kolumny AttributeValueID tabeli AttributeValue

Name

AttributeValueID

Code

AttributeValueID

Data Type

NUMBER(12)

Mandatory

Yes

Comment

 


Kolumna AttributeID tabeli AttributeValue

Definicja kolumny AttributeID tabeli AttributeValue

Name

AttributeID

Code

AttributeID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna DescriptiveDataID tabeli AttributeValue

Definicja kolumny DescriptiveDataID tabeli AttributeValue

Name

DescriptiveDataID

Code

DescriptiveDataID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna InterpretationTypeID tabeli AttributeValue

Definicja kolumny InterpretationTypeID tabeli AttributeValue

Name

InterpretationTypeID

Code

InterpretationTypeID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna DictionaryValueID tabeli AttributeValue

Definicja kolumny DictionaryValueID tabeli AttributeValue

Name

DictionaryValueID

Code

DictionaryValueID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna FormInstanceID tabeli AttributeValue

Definicja kolumny FormInstanceID tabeli AttributeValue

Name

FormInstanceID

Code

FormInstanceID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna UnitID tabeli AttributeValue

Definicja kolumny UnitID tabeli AttributeValue

Name

UnitID

Code

UnitID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna X tabeli AttributeValue

Definicja kolumny X tabeli AttributeValue

Name

X

Code

X

Data Type

NUMBER(5)

Mandatory

No

Comment

 


Kolumna Y tabeli AttributeValue

Definicja kolumny Y tabeli AttributeValue

Name

Y

Code

Y

Data Type

NUMBER(5)

Mandatory

No

Comment

 


Lista kluczy tabeli AttributeValue

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli AttributeValue

Definicja klucza Identifier_1 tabeli AttributeValue

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment